Forecast Revenue Summary Report

The Forecast Revenue Summary Report provides a projection of the number of rooms sold and expected revenue for the date range selected.  The Forecast Revenue Summary command in the Revenue Reports section of the Reports Area opens the Forecast Summary Report screen and allows you to generate a Report to your specifications for Rate Plans, Guest Types or Segments, or all of these. The Report may be generated for any one of your Properties or all Properties, and for any building within a Property.

Once generated, the report lists each day of the specified date range, with the rooms recap for that day, including rooms sold, number of complimentary rooms, rooms occupied, rooms off the market by do not sell, or out of order, and the occupancy.  The system also shows the room revenues for any wholesaler blocks, individual reservations (not part of a group), total revenue, and the average rate for that date.  The Date Range Totals on the report provide a running total of revenue and average rate. The bottom section of the report displays totals per column and a totals Recap including total rooms, total rooms available, total rooms occupied, occupancy %, total revenue and PTD (period to date) Average rate.

 

 

 

To reach the Reports Menu:

 

The Reports Menu can be accessed by clicking the Reports icon on the Action Bar:

Action Bar for Skyware Systems with words

OR

Full Menu

Click the icon on the left for the Full menu.

Full Menu Icon

This will display the Full menu in a tabular form, with four sections, Registration, Status, Cashier and Other.

Full Menu Table

From the Status Section, select Reports.

Status section of Full Menu with Reports option selected

 

The Reports screen is divided into four sections, Room Reports, Revenue Reports, Managers Reports and Other Reports.

Reports Menu screen

The Forecast Revenue Summary command is in the Revenue Reports section.

Revenue Reports section of the Reports Menu with the Forecast Revenue Summary command selected

 

When selected the Forecast Summary Report screen will open.

Forecast Summary Report screen example

Show All Hotels: This box may be checked or unchecked. By default it is unchecked, meaning the generated report will show information ONLY for the current Property. For this report, you may choose to show the information from ALL your Properties within Skyware on one report, rather than generating separate reports for each Property.

 

Date Range (by Departure Date): You will need to specify the Date Range for the Report.

From: Click anywhere in the field to open the calendar and select the Date you wish to have the Reporting begin for the report. By default the Date selected is the first day of the current month.

To: Click anywhere in the field to open the calendar and select the Date you wish to have the Reporting end for the report. By default the Date selected is the last day of the current month.

 

Report Options: Choose the options you want to view in this report.

Revenue Type Categories: Choose ONE option using the radial buttons. You may select from: All, Rate Plans, Guest Types or Segments. By default All is selected.

Note: If you select Rate Plans, Guest Types or Segments, you may then select one or more of the sub classifications that will appear within the list box.

Report option choices, with all selected or rate plan selected now showing the sub classifications for individual selection in the list boz

By default ALL options that appear within the section are selected (appear in gray). To select less than all, click on the desired option for one selection, or hold down the CTRL key while selecting each to make multiple selections from the list.

 

Building: This is a drop-down menu of available building options. By default the option -ALL- is selected. Select one or leave as -ALL-. This allows you to narrow the report focus to one particular building, if desired.

Show Summary by Month: This box may be checked or unchecked. By default it is unchecked. If checked, the report will show the information by month rather than by individual day over the specified Date range.

Exclude Groups Un-Picked Up Rooms: This box may be checked or unchecked. By default it is unchecked. Use this option to select whether to exclude Groups Un-Picked Up rooms from the reporting

Exclude Wholesalers Un-Picked Up Rooms: This box may be checked or unchecked. By default it is unchecked. Use this option to select whether to exclude Wholesalers Un-Picked Up rooms from the reporting.

 

When finished, click the orange button Print Forecast.

Forecast Summary Report example

Once generated, the report lists each day or each month of the specified date range, with the Recap (Totals) section at the bottom, including total rooms, total rooms available, total rooms occupied, occupancy %, total revenue and PTD (period to date) Average rate.

 

Note: If you select Rate Plans, Guest Types or Segments for the Revenue Type option to show on the report, rather than All, as well as the Recap section, there will be a final page (after the Recap section) showing the totals for the individual Rate Plans, Guest Types or Segments selections made.

For example: By Rate Plan, with Rack Rate and Sale Rate selected.

Forecast Summary Report by Rate Plan showing recap and showing individual totals

 

By default, the report is generated in PDF form and opens in a separate browser window. From there you can select to save or print the report, among other options. You can, instead, check the Generate report to excel checkbox to generate the report in HTML for downloading to Excel instead of PDF, or use the checkbox Generate report to Excel (data only) to generate the data only for importing into another document rather than immediate viewing.

NOTE: The generated report appears as a pop-up window through your browser. If your browser is set to block pop-ups, you may receive a warning banner at the top of the browser. Click this banner and select to allow pop-ups so that you can view the report.

 

Date Updated April 07, 2022